﻿-- Ajout de la colonne IsVersionned à la table medianamik_Type
	
IF NOT EXISTS(
Select * FROM Information_Schema.COLUMNS
where TABLE_SCHEMA = 'dbo'
AND TABLE_NAME = 'medianamik_Type'
AND Column_Name = 'IsVersioned'
)
BEGIN
	ALTER TABLE dbo.medianamik_Type ADD
	IsVersioned bit NOT NULL CONSTRAINT DF_medianamik_Type_IsVersioned DEFAULT 1
END